The teaching of Relational On-Line Analytical Processing (ROLAP) in Advanced Database courses.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. To copy otherwise, to republish, to post on servers or to redistribute to lists, requires prior specific permission. © 2012 Higher Education AcademyDatabases are taught as a core subject at undergraduate and postgraduate levels in computer science degrees. The subject is often divided into conceptual database design and database technologies including physical database design. One of the problems with teaching the topic of ROLAP and Data Warehousing is the difficulty of providing practical exposure to the students. The approach taken in this work is intended to help students apply their knowledge learnt throughout the subject and gain some practical understanding leading to its application and implementation which furthermore provides the basis for analysis and evaluation at the level of critical analysis that would be expected on an advanced level course and at the highest level of learning taxonomies. In our work we have reverse engineered a large Oracle sample dataset and adapted it for use in the teaching of ROLAP. We have also produced our own smaller sample dataset for simplification and understanding of complex queries involving Slicing, Dicing , Pivoting, Rollup and Cube operations. In our examples ROLAP operations and their alternative SQL approaches are performed to provide multi-dimensional results

Prevalence and management of aphids (Hemiptera: Aphididae) in different wheat genotypes and their impact on yield and related traits.

Wheat (Triticum aestivum L.) production is significantly altered by the infestation of sucking insects, particularly aphids. Chemical sprays are not recommended for the management of aphids as wheat grains are consumed soon after crop harvests. Therefore, determining the susceptibility of different wheat genotypes and selecting the most tolerant genotype could significantly lower aphid infestation. This study evaluated the susceptibility of six different wheat genotypes (‘Sehar-2006’, ‘Shafaq-2006’, ‘Faisalabad-2008’, ‘Lasani-2008’, ‘Millat-2011’ and ‘Punjab-2011’) to three aphid species (Rhopalosiphum padi Linnaeus, Schizaphis graminum Rondani, Sitobion avenae Fabricius) at various growth stages. Seed dressing with insecticides and plant extracts were also evaluated for their efficacy to reduce the incidence of these aphid species. Afterwards, an economic analysis was performed to compute cost-benefit ratio and assess the economic feasibility for the use of insecticides and plant extracts. Aphids’ infestation was recorded from the seedling stage and their population gradually increased as growth progressed towards tillering, stem elongation, heading, dough and ripening stages. The most susceptible growth stage was heading with 21.89 aphids/tiller followed by stem elongation (14.89 aphids/tiller) and dough stage (13.56 aphids/tiller). The genotype ‘Punjab-2011’ recorded the lower aphid infestation than ‘Faisalabad-2008’, ‘Sehar-2006’, ‘Lasani-2008’ and ‘Shafaq-2006’. Rhopalosiphum padi appeared during mid-February, whereas S. graminum and S. avenae appeared during first week of March. Significant differences were recorded for losses in number of grains/spike and 1000-grain weight among tested wheat genotypes. The aphid population had non-significant correlation with yield-related traits. Hicap proved the most effective for the management of aphid species followed by Hombre and Husk among tested seed dressers, while Citrullus colocynthis L. and Moringa oleifera Lam. plant extracts exhibited the highest efficacy among different plant extracts used in the study. Economic analysis depicted that use of Hombre and Hicap resulted in the highest income and benefit cost ratio. Therefore, use of genotype Punjab-2011’ and seed dressing with Hombre and Hicap can be successfully used to lower aphid infestation and get higher economic returns for wheat crop

Study protocol of DIVERGE, the first genetic epidemiological study of major depressive disorder in Pakistan

INTRODUCTION: Globally, 80% of the burdenof major depressive disorder (MDD) pertains to low- and middle-income countries. Research into genetic and environmental risk factors has the potential to uncover disease mechanisms that may contribute to better diagnosis and treatment of mental illness, yet has so far been largely limited to participants with European ancestry from high-income countries. The DIVERGE study was established to help overcome this gap and investigate genetic and environmental risk factors for MDD in Pakistan. METHODS: DIVERGE aims to enrol 9000 cases and 4000 controls in hospitals across the country. Here, we provide the rationale for DIVERGE, describe the study protocol and characterise the sample using data from the first 500cases. Exploratory data analysis is performed to describe demographics, socioeconomic status, environmental risk factors, family history of mental illness and psychopathology. RESULTS AND DISCUSSION: Many participants had severe depression with 74% of patients who experienced multiple depressive episodes. It was a common practice to seek help for mental health struggles from faith healers and religious leaders. Socioeconomic variables reflected the local context with a large proportion of women not having access to any education and the majority of participants reporting no savings. CONCLUSION: DIVERGE is a carefully designed case-control study of MDD in Pakistan that captures diverse risk factors. As the largest genetic study in Pakistan, DIVERGE helps address the severe underrepresentation of people from South Asian countries in genetic as well as psychiatric research

The global burden of cancer attributable to risk factors, 2010-19 : a systematic analysis for the Global Burden of Disease Study 2019

Background Understanding the magnitude of cancer burden attributable to potentially modifiable risk factors is crucial for development of effective prevention and mitigation strategies. We analysed results from the Global Burden of Diseases, Injuries, and Risk Factors Study (GBD) 2019 to inform cancer control planning efforts globally. Methods The GBD 2019 comparative risk assessment framework was used to estimate cancer burden attributable to behavioural, environmental and occupational, and metabolic risk factors. A total of 82 risk-outcome pairs were included on the basis of the World Cancer Research Fund criteria. Estimated cancer deaths and disability-adjusted life-years (DALYs) in 2019 and change in these measures between 2010 and 2019 are presented. Findings Globally, in 2019, the risk factors included in this analysis accounted for 4.45 million (95% uncertainty interval 4.01-4.94) deaths and 105 million (95.0-116) DALYs for both sexes combined, representing 44.4% (41.3-48.4) of all cancer deaths and 42.0% (39.1-45.6) of all DALYs. There were 2.88 million (2.60-3.18) risk-attributable cancer deaths in males (50.6% [47.8-54.1] of all male cancer deaths) and 1.58 million (1.36-1.84) risk-attributable cancer deaths in females (36.3% [32.5-41.3] of all female cancer deaths). The leading risk factors at the most detailed level globally for risk-attributable cancer deaths and DALYs in 2019 for both sexes combined were smoking, followed by alcohol use and high BMI. Risk-attributable cancer burden varied by world region and Socio-demographic Index (SDI), with smoking, unsafe sex, and alcohol use being the three leading risk factors for risk-attributable cancer DALYs in low SDI locations in 2019, whereas DALYs in high SDI locations mirrored the top three global risk factor rankings. From 2010 to 2019, global risk-attributable cancer deaths increased by 20.4% (12.6-28.4) and DALYs by 16.8% (8.8-25.0), with the greatest percentage increase in metabolic risks (34.7% [27.9-42.8] and 33.3% [25.8-42.0]). Interpretation The leading risk factors contributing to global cancer burden in 2019 were behavioural, whereas metabolic risk factors saw the largest increases between 2010 and 2019. Reducing exposure to these modifiable risk factors would decrease cancer mortality and DALY rates worldwide, and policies should be tailored appropriately to local cancer risk factor burden. Copyright (C) 2022 The Author(s). Published by Elsevier Ltd. This is an Open Access article under the CC BY 4.0 license.Peer reviewe

The global burden of cancer attributable to risk factors, 2010–19: a systematic analysis for the Global Burden of Disease Study 2019

BACKGROUND: Understanding the magnitude of cancer burden attributable to potentially modifiable risk factors is crucial for development of effective prevention and mitigation strategies. We analysed results from the Global Burden of Diseases, Injuries, and Risk Factors Study (GBD) 2019 to inform cancer control planning efforts globally. METHODS: The GBD 2019 comparative risk assessment framework was used to estimate cancer burden attributable to behavioural, environmental and occupational, and metabolic risk factors. A total of 82 risk–outcome pairs were included on the basis of the World Cancer Research Fund criteria. Estimated cancer deaths and disability-adjusted life-years (DALYs) in 2019 and change in these measures between 2010 and 2019 are presented. FINDINGS: Globally, in 2019, the risk factors included in this analysis accounted for 4·45 million (95% uncertainty interval 4·01–4·94) deaths and 105 million (95·0–116) DALYs for both sexes combined, representing 44·4% (41·3–48·4) of all cancer deaths and 42·0% (39·1–45·6) of all DALYs. There were 2·88 million (2·60–3·18) risk-attributable cancer deaths in males (50·6% [47·8–54·1] of all male cancer deaths) and 1·58 million (1·36–1·84) risk-attributable cancer deaths in females (36·3% [32·5–41·3] of all female cancer deaths). The leading risk factors at the most detailed level globally for risk-attributable cancer deaths and DALYs in 2019 for both sexes combined were smoking, followed by alcohol use and high BMI. Risk-attributable cancer burden varied by world region and Socio-demographic Index (SDI), with smoking, unsafe sex, and alcohol use being the three leading risk factors for risk-attributable cancer DALYs in low SDI locations in 2019, whereas DALYs in high SDI locations mirrored the top three global risk factor rankings. From 2010 to 2019, global risk-attributable cancer deaths increased by 20·4% (12·6–28·4) and DALYs by 16·8% (8·8–25·0), with the greatest percentage increase in metabolic risks (34·7% [27·9–42·8] and 33·3% [25·8–42·0]). INTERPRETATION: The leading risk factors contributing to global cancer burden in 2019 were behavioural, whereas metabolic risk factors saw the largest increases between 2010 and 2019. Reducing exposure to these modifiable risk factors would decrease cancer mortality and DALY rates worldwide, and policies should be tailored appropriately to local cancer risk factor burden

Reported Male Circumcision Practices in a Muslim-Majority Setting

Introduction. Male circumcision is a recommended practice in Muslim tradition. It is important to ensure that this procedure is performed as safely as possible in these communities. Methods. Five hundred adult men and women with at least one male child less than 18 years were interviewed in Karachi, Pakistan, regarding details of their child’s circumcision. The survey focused on actual and perceived delays in circumcision and perceptions about appropriate age and reasons and benefits and complications of the procedure. Circumcisions done after two months of age were defined as delayed. Results. Religious requirement was the primary reason for circumcision in 92.6% of children. However, 89.6% of respondents were of the opinion that circumcision had medical benefits as well. Half of the children (54.1%) had delayed circumcision (range 2.5 months to 13 years), even though 81.2% of parents were of the opinion that circumcisions should be done within 60 days of birth. Facility-delivered babies had less delay in circumcisions (49.1%) as compared to home-delivered babies (60.5%). Conclusion. Understanding the perceptions and practices around male circumcision can help guide national strategies for designing and implementing safe circumcision programs in Muslim-majority settings, with the potential to benefit an annual birth cohort of 20–25 million boys worldwide

Atomic Layer Deposition—A Versatile Toolbox for Designing/Engineering Electrodes for Advanced Supercapacitors

Abstract Atomic layer deposition (ALD) has become the most widely used thin‐film deposition technique in various fields due to its unique advantages, such as self‐terminating growth, precise thickness control, and excellent deposition quality. In the energy storage domain, ALD has shown great potential for supercapacitors (SCs) by enabling the construction and surface engineering of novel electrode materials. This review aims to present a comprehensive outlook on the development, achievements, and design of advanced electrodes involving the application of ALD for realizing high‐performance SCs to date, as organized in several sections of this paper. Specifically, this review focuses on understanding the influence of ALD parameters on the electrochemical performance and discusses the ALD of nanostructured electrochemically active electrode materials on various templates for SCs. It examines the influence of ALD parameters on electrochemical performance and highlights ALD's role in passivating electrodes and creating 3D nanoarchitectures. The relationship between synthesis procedures and SC properties is analyzed to guide future research in preparing materials for various applications. Finally, it is concluded by suggesting the directions and scope of future research and development to further leverage the unique advantages of ALD for fabricating new materials and harness the unexplored opportunities in the fabrication of advanced‐generation SCs